SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].ProductosSelectCommandByMarca
(
	@MARCA varchar(100)
)
AS
	SET NOCOUNT ON;
SELECT        PRODUCTOS.*
FROM            PRODUCTOS INNER JOIN
                         MARCAS ON PRODUCTOS.ID_MARCA = MARCAS.ID
WHERE        (MARCAS.MARCA LIKE '%' + @MARCA + '%')
GO
